You are here: Understanding the Meridian object model > About the Vault object > The Vault object methods > ExecSQL method

ExecSQL method

Executes an SQL query using the specified connection string.

Syntax

ExecSQL(Connection As String, Query As String, [Parameters])
Parameters
Name Description

Connection

A valid connection string for the database with which to execute the query.

This parameter also accepts a variable that represents one of the following vault databases described in the table. The variables are case-sensitive.

$$TransManDB – The Transmittal Management Module database (if installed)

$$UserDB – The user account database

Note    When the Use Enterprise Server for user management option is enabled in the EDM Server properties in Meridian Enterprise Administrator, the reserved word $$UserDB cannot be used in VBScript with the Vault.ExecSQL method to access the Meridian Enterprise Server user database.

$$<QueryName> – An external table query connection string created as described in the BlueCielo Meridian Enterprise Configuration Guide.

Query

A valid SQL query expression.

Parameters

Optional parameters.

Related concepts

About the Vault object 


www.bluecieloecm.com